Caution:Performing a Query
The term Query refers to the search for data based on specific search criteria. In Chromeleon, you can search for samples and the corresponding sequences based on freely selectable parameters. Either you can use very detailed criteria to search for one specific sample, or you can use criteria that are more general to search for a specific series of samples with the same properties.
Caution:
Make sure that you back up the entire sequence and not only the samples found during the query if you want to delete the original data after the backup. Before deleting the original data, verify that the backup file contains all samples.
How To
In the Browser, select Query on the context menu. Or else, select New > Query (using the Wizard) on the File menu. Either way, a Wizard guides in entering the required conditions.
On the first wizard page, determine the Datasource in which the query is performed. Also, determine whether the query is performed for Sequence properties (Sequences) and/or sample properties (Samples), and/or other conditions (Results).
Clicking Next> takes you to the next wizard page(s). The pages that are opened depend on the properties selected on the first wizard page. Determine the search criteria.
Click Finish to open the New Query Properties dialog box, which provides four tab pages:
Use the General tab page to select the datasource in which the query is performed.
Use the Native SQL tab page to edit the SQL statements directly in the SQL syntax of the corresponding ODBC driver (contains translated Chromeleon statements).
Use the SQL tab page to edit the search statement in an entry dialog box.
Use the Result Restrictions tab page to limit the resulting sample list by more result queries.
For more information, refer to:
Entering the Sample Query Using the Wizard
Selecting Search Criteria for Samples and/or Sequences
Examples (Wizard)
Specifying the Sample Query Using the Dialog Box
Examples (Dialog Box)
Editing a Query in SQL Syntax
Saving and Performing a Query